﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

namespace UtilsORM.MySqlData;

[Index("p_guid", Name = "p_guid")]
[Index("p_status", Name = "p_status")]
[MySqlCharSet("utf8mb3")]
[MySqlCollation("utf8mb3_general_ci")]
public partial class iot_product
{
    [Key]
    public long p_id { get; set; }

    [StringLength(50)]
    public string p_code { get; set; }

    /// <summary>
    /// 0正常，1禁用
    /// </summary>
    public int? p_status { get; set; }

    [StringLength(50)]
    public string p_guid { get; set; }

    /// <summary>
    /// 类型名称
    /// </summary>
    [StringLength(100)]
    public string p_name { get; set; }

    [Column(TypeName = "datetime")]
    public DateTime? p_add_time { get; set; }

    /// <summary>
    /// 客户
    /// </summary>
    [StringLength(50)]
    public string p_c_guid { get; set; }

    /// <summary>
    /// 备注
    /// </summary>
    [StringLength(255)]
    public string p_remark { get; set; }

    /// <summary>
    /// 校验码
    /// </summary>
    [StringLength(255)]
    public string p_check_code { get; set; }

    /// <summary>
    /// 产品型号
    /// </summary>
    [StringLength(50)]
    public string p_pm_guid { get; set; }

    [Column(TypeName = "datetime")]
    public DateTime? p_mod_time { get; set; }

    /// <summary>
    /// 场景名称
    /// </summary>
    [StringLength(255)]
    public string p_scene_name { get; set; }
}
